VARIABLE siteName VARCHAR2(100)
EXECUTE :siteName := '&1';

DELETE FROM RA$Pages
 WHERE folderID IN (
        SELECT folderID
          FROM RA$Folders
         WHERE siteName = :siteName);

DELETE FROM RA$Folders
 WHERE siteName = :siteName;

DELETE FROM RA$PermissionSets
 WHERE siteName = :siteName;

DELETE FROM RA$Sites
 WHERE siteName = :siteName;